|
4984 Search Results Found |
1 |
Forum: Performance Tuning «»
Posted on: Tue, 18 October 2022 11:07 «»
By: nishant1987
Re: Sql behaving badly after upgrade
…RC ,APPS.RA_BATCH_SOURCES BS
,APPS.MTL_SYSTEM_ITEMS_B MS ,APPS.MTL_SYSTEM_ITEMS_TL MT
,APPS.CST_ITEM_COST_TYPE_V CSTI ,APPS.HR_LOCATIONS HLA ,APPS.HZ_PARTIES
HPA ,APPS.HZ_CUST_ACCOUNTS HCA ,APPS.HZ_PARTY_SITES HPS
,APPS.HZ_LOCATIONS HLO ,APPS.…
|
2 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 05 March 2002 01:48 «»
By: Glennters
system requirements
what are the minimum system requierements for installing oracle database?
|
3 |
Forum: Performance Tuning «»
Posted on: Tue, 18 October 2022 10:55 «»
By: nishant1987
Re: Sql is causing performance issue
… INDEX UNIQUE SCAN | MTL_SYSTEM_ITEMS_B_U1 | 1 | | | 2 (0)| 00:00:01 |
| 76 | D TABLE ACCESS BY INDEX ROWI | MTL_SYSTEM_ITEMS_B | 1 | 32…
|
4 |
Forum: Backup & Recovery «»
Posted on: Tue, 01 March 2022 07:57 «»
By: patdev
Re: RMAN resotre/clone to new server
…*********
Tue Mar 01 07:48:29 2022
Dump of system resources acquired for SHARED GLOBAL AREA (SGA)
Tue Mar 01 07:48:29 2022
Per process system memlock (soft) limit = 30G
Tue Mar 01 07:48:29 2022
Expected per process system memlock (soft) limit …
|
5 |
Forum: Cloud and Hosting «»
Posted on: Fri, 24 November 2023 11:12 «»
By: John Watson
firewalld and DB System nodes
…System nodes have the firewall not only disabled but masked:[root@agoco ~]#
[root@agoco ~]# systemctl status firewalld
● firewalld.service
Loaded: masked (/dev/null; bad)
Active: inactive (dead)
[root@agoco ~]#
[root@agoco ~]#there is no way that …
|
6 |
Forum: Marketplace «»
Posted on: Sun, 20 March 2016 11:35 «»
By: Michel Cadot
McOptions: a program which allows to know which options are used in a database
…bsp; 32 Currently used
SQL Tuning Set (system) Yes  …
|
7 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 09 January 2024 08:31 «»
By: wtolentino
Grants of System Privileges Thru Stored Procedure
… have this procedure that dynamically grants system privileges that when executed is giving me error "ORA-01031: insufficient privileges". However, when the same grant command alone is executed it is working fine.
SQL> select user from …
|
8 |
Forum: Server Administration «»
Posted on: Sat, 01 April 2023 09:14 «»
By: evoradba
system ORACLE ID all objects were removed
…m, my UNIX admin logged into the database as system and run some command that removed all tables under the system ID. I do have a backup, but is datapump if I try to restore the data from the backup I get these msg
ORA-31626: job does not exist
ORA-…
|
9 |
Forum: Server Utilities «»
Posted on: Sun, 16 June 2024 12:41 «»
By: orHooha
Not able to run expdp
…create job SYS_EXPORT_FULL_03 for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 798
ORA-31635: unable to establish job resource synchronization
system@DOCT>SELECT owner_name, …
|
10 |
Forum: Data Guard «»
Posted on: Thu, 28 September 2023 13:30 «»
By: LIPEKA
Re: RMAN-00554 RMAN-04006
… for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/salesprd/alert/log.xml
Listening on: (DESCRIPTION=(…
|
11 |
Forum: Text & interMedia «»
Posted on: Tue, 15 August 2023 16:36 «»
By: Barbara Boehmer
Re: How to determine last tiime Content was indexed
…are some things that are specific to my system that you will need to change before running it on yours, such as operating system directory name and the file name of some text file for testing in that directory. I created an example.dat file that …
|
12 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 30 September 2022 09:08 «»
By: nishant1987
ANSI JOIN requirement
…
-- FROM apps.mtl_system_items_b items
-- WHERE items.inventory_item_id = pll.item_id
-- AND items.organization_id = ploc.SHIP_TO_ORGANIZATION_ID)
-- "PreProcessing_LT"…
|
13 |
Forum: Server Administration «»
Posted on: Mon, 22 April 2024 15:28 «»
By: Michel Cadot
Re: Traditional auditing: how to query existing audits?
…nbsp;grant, revoke, audit, noaudit and alter system
DBA_AUDIT_TRAIL All audit trail entries
DBA_COMMON_AUDIT_TRAIL …
|
14 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 27 September 2022 23:52 «»
By: nishant1987
Sql is causing performance issue
…
FROM apps.mtl_system_items_b items
WHERE items.inventory_item_id = pll.item_id
AND items.organization_id = ploc.SHIP_TO_ORGANIZATION_ID)
"PreProcessing_LT",
(SELECT /*+ use_nl (msib …
|
15 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 12 August 2024 23:28 «»
By: shahzad-ul-hasan
Re: diffrence between two chacter fields.
… photo_filename VARCHAR2(80);
BEGIN
:system.message_level:='25';
select distinct ename ,desig,dept
into :sin.name, :sin.cls,:sin.d
from EMP
where EMP.eid=:ID and estat='ACTIVE';
BEGIN
SELECT intime,otime INTO :SIN.intime,:SIN.otime FROM …
|
16 |
Forum: Server Administration «»
Posted on: Tue, 23 April 2024 00:25 «»
By: Michel Cadot
Re: Traditional auditing: how to query existing audits?
…sp; Describes current system privileges being audited across the system and by user
DBA_STMT_AUDIT_OPTS Describes current system auditing options across the system …
|
17 |
Forum: Security «»
Posted on: Thu, 07 March 2024 08:42 «»
By: Michel Cadot
Re: Max string size for regular users
…can.
A developer can read and modify all system variables? No.
An administrator can.
NLS_LANGUAGE is a client variable, user can read (using NLS_SESSION_PARAMETERS view) and overwrite (using ALTER SESSION) NLS variables but can't declare or …
|
18 |
Forum: Backup & Recovery «»
Posted on: Wed, 12 July 2023 10:29 «»
By: Andrey_R
Re: RMAN restore - only DB backup ( no SF\CF\archivelog backup )
…
ORA-01110: data file 1: '**:\....MYDB3\SYSTEM01.DBF'
RMAN> quit
So I went again and created a spfile , bounced my instance and set params with
SQL> alter system set undo_management=manual scope=spfile;
System altered.
SQL> ALTER …
|
19 |
Forum: Data Guard «»
Posted on: Wed, 17 May 2023 00:46 «»
By: John Watson
Re: PROS and CONS of cross platform dataguard(Linux and windows)
…they intend to switch over to the Windows system and then drop the Linux system, great! Zero downtime for the move! If they intend to use the Windows system in the event of failure of the Linux system, well, forget it. Think of such basic things as …
|
20 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 08 March 2023 12:07 «»
By: mathguy
Re: Different UTC time from SYSDATE on different databases
…tell us if the time of logon is at "system" time zone (from the operating system running the server), or at SESSIONTIMEZONE, or some other time zone. At least the system time zone and SESSIONTIMEZONE make sense in this context, and in general we…
|
21 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 08 March 2023 09:26 «»
By: Michel Cadot
Re: Different UTC time from SYSDATE on different databases
… current date and time set for the operating system on which the database server resides".
It has no time zone information and is neither in db time zone nor session time zone.
You cannot extract UTC from SYSDATE unless you know your operating …
|
22 |
Forum: Data Guard «»
Posted on: Sat, 11 February 2023 11:31 «»
By: Andrey_R
Re: RMAN-06820 on rman backup from standby with OS authentication
…ry. I imitated it with
SQL> alter system archive log current;
System altered.
SQL>
Then I backed up only the archivelogs on standby
RMAN> BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL not backed up 1 times FORMAT 'F:\…
|
23 |
Forum: Performance Tuning «»
Posted on: Tue, 18 October 2022 11:05 «»
By: nishant1987
Re: Sql behaving badly after upgrade
… BS,
APPS.MTL_SYSTEM_ITEMS_B MS,
APPS.MTL_SYSTEM_ITEMS_TL MT,
APPS.CST_ITEM_COST_TYPE_V CSTI,
APPS.HR_LOCATIONS HLA,
APPS.HZ_PARTIES HPA…
|
24 |
Forum: Performance Tuning «»
Posted on: Tue, 18 October 2022 10:54 «»
By: nishant1987
Sql behaving badly after upgrade
… BS,
APPS.MTL_SYSTEM_ITEMS_B MS,
APPS.MTL_SYSTEM_ITEMS_TL MT,
APPS.CST_ITEM_COST_TYPE_V CSTI,
APPS.HR_LOCATIONS HLA,
APPS.HZ_PARTIES HPA…
|
25 |
Forum: Performance Tuning «»
Posted on: Tue, 18 October 2022 10:51 «»
By: nishant1987
Re: Sql is causing performance issue
… BS,
APPS.MTL_SYSTEM_ITEMS_B MS,
APPS.MTL_SYSTEM_ITEMS_TL MT,
APPS.CST_ITEM_COST_TYPE_V CSTI,
APPS.HR_LOCATIONS HLA,
APPS.HZ_PARTIES HPA…
|
26 |
Forum: Performance Tuning «»
Posted on: Tue, 18 October 2022 10:48 «»
By: nishant1987
Sql behaving badly after upgrade (merged)
… BS,
APPS.MTL_SYSTEM_ITEMS_B MS,
APPS.MTL_SYSTEM_ITEMS_TL MT,
APPS.CST_ITEM_COST_TYPE_V CSTI,
APPS.HR_LOCATIONS HLA,
APPS.HZ_PARTIES HPA…
|
27 |
Forum: Backup & Recovery «»
Posted on: Mon, 07 March 2022 07:55 «»
By: Michel Cadot
Re: TABLE POINT IN TIME RECOVERY
…ORA-01552: cannot use system rollback segment for non-system tablespace '%s'
*Cause: Tried to use the system rollback segment for operations involving
non-system tablespace. If this is a clone database then this will
happen when …
|
28 |
Forum: Reports & Discoverer «»
Posted on: Fri, 10 May 2024 02:36 «»
By: Rizwi
show REP-1246 DOCUMENT IS NOT FOUND
…forms and Report instally my system and form6i install on company server and Report design in my system not server. i have share the folder my system folder to server and mapping to Y drive.
report compile run paper layout then run report and graph. &…
|
29 |
Forum: Forms «»
Posted on: Thu, 09 May 2024 03:34 «»
By: Rizwi
Re: Problem calling a report from that have a chart
…forms and Report instally my system and form6i install on company server and Report design in my system not server. i have share the folder my system folder to server and mapping to Y drive.
report compile run paper layout then run report and graph. &…
|
30 |
Forum: SQL & PL/SQL «»
Posted on: Sun, 17 March 2024 17:06 «»
By: Darth Waiter
Re: Do users ever create tables in these schemas?
…that user tables can be expected in any of system schemas because it is technically possible to create them everywhere. An arbitrary DBA or developer may create them even under SYS and grant permissions, so if one is looking for user tables then exclusion…
|
31 |
Forum: Security «»
Posted on: Fri, 08 March 2024 06:39 «»
By: cookiemonster
Re: Max string size for regular users
…line - it's the way it is because it's a system parameter and 99.999999999% (add more decimal 9s to taste) of the time normal users don't need to know what the system parameters are set to.
You've got a deeply non-standard setup and are complaining that …
|
32 |
Forum: Reports & Discoverer «»
Posted on: Fri, 16 February 2024 02:26 «»
By: Littlefoot
Re: GOBAT60.EXE HAS STOP WORKING
… Windows Server 2012 (not that new operating system), but - regarding the fact that Forms (and Reports) 6i was last certified with MS Windows XP (which was released in 2001), then your problem might be in incompatibility between Oracle software and …
|
33 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 13 February 2024 18:56 «»
By: Duane
Read BLOB from Table into CLOB for further processing
…in a table and the file is put on our OS system. An External Table is used to read the contents of the file from the OS. Those contents are processed.
New Process:
A file is uploaded to a BLOB column in a table. The file won't …
|
34 |
Forum: Linux «»
Posted on: Wed, 29 November 2023 10:02 «»
By: John Watson
Re: Oracle database and SELinux
…for replying. I'm working on OCI DB System nodes, and the way they configure ASM with udev I think looks OK.
However, I do find this worrying: no SELinux on a DB System, and not on ExaCC either! Does Uncle Oracle really not want us to use it? I guess I…
|
35 |
Forum: Backup & Recovery «»
Posted on: Thu, 06 July 2023 07:57 «»
By: Andrey_R
Re: RMAN restore - only DB backup ( no SF\CF\archivelog backup )
…, and cleared all Application\Security\Setup\System\Forwarded Events log data.
Then tried again - got the exact same result
RMAN> RECOVER TABLE "MYUSER"."T1"
2> UNTIL TIME "TO_DATE('06.07.2023 11:47:00', 'DD-MM-YYYY…
|
36 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 08 March 2023 09:21 «»
By: mathguy
Re: Different UTC time from SYSDATE on different databases
…, both are in the time zone of the operating system on the computer where the database is running. Sometimes that is the same as DBTIMEZONE, but sometimes it isn't. SYSTIMESTAMP "knows" what time zone it is in: when the value is retrieved by the…
|
37 |
Forum: Backup & Recovery «»
Posted on: Fri, 27 January 2023 21:14 «»
By: Barbara Boehmer
Re: ora-12203 TNS unable to connect
…, then you are missing target.
C:\Windows\System32>rman target system/system@orcl
Recovery Manager: Release 12.1.0.2.0 - Production on Fri Jan 27 19:09:00 2023
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
…
|
38 |
Forum: Text & interMedia «»
Posted on: Tue, 10 January 2023 12:15 «»
By: Barbara Boehmer
Re: Oracle Text Search - Handling special characters and blank search term
…is the on-demand availability of computer system resources, espe
cially data storage and computing power, without direct active management by the
user.
50.5
1 row selected.
SCOTT@orcl_12.1.0.2.0> EXEC :P2_SEARCH_TERM := NULL
PL/SQL…
|
39 |
Forum: Performance Tuning «»
Posted on: Sat, 23 July 2022 07:39 «»
By: John Watson
Re: Time metrics in V$SQL don't add up
…I've used this test:alter system flush buffer_cache;
alter system flush shared_pool;
set feedback on sql_id
alter session set tracefile_identifier=jw;
exec dbms_monitor.session_trace_enable(waits=>true)
select sum(amount_sold) from sh.sales;
exec…
|
40 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 21 April 2022 14:19 «»
By: buggleboy007
How to append a header on the top of the CSV file
…ERENCE_NUMBER,CUSTOMER_ID,TRANSACTION_NUMBER,SYSTEM_ID,DETAIL_CODE,MCGILL_ID,TERM_CODE,TRANS_DATE,PAYMENT_ID,AMOUNT,APPROVAL_CODE,TRANS_AMT,ORDER_NUMBER,TYPE_IND,DR_CR_IND,DESCRIPTION,TYPE
Here is how it looks (after appending the text):
66032180,1,…
|